Nic Larsen

Overview

Overview
Roles	Member
Badges	41

About Me
Not much happening here, yet.

526

Posts

2,457

Visits

11.4k

Points

Jun 26, 2018

Join Date

10:16 pm

Last Active

Re: Formula help needed - if/then

Nic Larsen

11/20/24

Try: =IF(CONTAINS("Priority", [Type of CPG]@row), [Meeting Date]@row - 21, [Meeting Date]@row - 14)

2 ·
Re: I have multiple nested formulas but one doesn't return anything... Help

Nic Larsen

11/13/24

Try this: =IF([% Complete]@row = "X", "On Hold / Cancelled", IF([% Complete]@row = 1, "Complete", IF(AND(OR(ISBLANK([% Complete]@row), [% Complete]@row = 0), Start@row &…

1 ·
Re: Need IF statement to return a value based on sum between two numbers

Nic Larsen

10/17/24

Try: =IF([Total Sum]@row >= 50000, "VP", IF(AND([Total Sum]@row <= 2,000, [Total Sum]@row > 500), "A", IF(AND([Total Sum]@row <= 5000, [Total Sum]@row > 2000.01, &q…

1 ·
Re: If(and( question

Nic Larsen

10/15/24

You have AND statements after the 1st one that are not 2 items to test before the result. Try: =IF(AND([Development Tier]@row = "Version Change/Iterative Product Update", [Stage Gate]@row =…

1 ·
Re: Changing Status Symbol from "Hold" to "Yes" depending on dropdown menu entry

Nic Larsen

09/23/24

Use: =IF([Last Report Type]@row = "E-MAIL", "Hold", IF([Last Report Type]@row = "REPORT", "YES", "")

1 ·